home *** CD-ROM | disk | FTP | other *** search
/ Complete Linux / Complete Linux.iso / docs / apps / database / postgres / postgre1.z / postgre1 / bench / query13 < prev    next >
Encoding:
Text File  |  1992-08-27  |  772 b   |  5 lines

  1. retrieve into temp (t.all,Bunique1=B.unique1,Bunique2=B.unique2,Btwo=B.two,Bfour=B.four,Bten=B.ten,Btwenty= B.twenty, Bhundred=B.hundred,Bthousand=B.thousand,Btwothousand=B.twothousand,Bfivethous=B.fivethous,Btenthous=B.tenthous,Bodd=B.odd, Beven=B.even,Bstringu1=B.stringu1,Bstringu2=B.stringu2,Bstring4=B.string4) from t in tenk1, B in Bprime where t.unique2 = B.unique2
  2. destroy temp
  3. retrieve into temp (t.all,Bunique1=B.unique1,Bunique2=B.unique2,Btwo=B.two,Bfour=B.four,Bten=B.ten,Btwenty= B.twenty, Bhundred=B.hundred,Bthousand=B.thousand,Btwothousand=B.twothousand,Bfivethous=B.fivethous,Btenthous=B.tenthous,Bodd=B.odd, Beven=B.even,Bstringu1=B.stringu1,Bstringu2=B.stringu2,Bstring4=B.string4) from t in tenk1, B in Bprime where t.unique2 = B.unique2
  4. destroy temp
  5.